<%@ Page Title="" Language="C#" MasterPageFile="~/Admin/Admin.master" AutoEventWireup="true"
    CodeFile="AddSchedule.aspx.cs" Inherits="Admin_AddSchedule" %>

<asp:content id="Content1" contentplaceholderid="ContentPlaceHolder1" runat="Server">
    <h3 align="center">
        Add Schedule</h3>
    <div>
        Choose Route :
        <asp:dropdownlist id="DropDownList1" runat="server" datasourceid="SqlDataSource1"
            datatextfield="Route Name" datavaluefield="RouteID">
        </asp:dropdownlist>
        <asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:sqlString %>"
            selectcommand="SELECT Airline_Route.RouteID, 'FROM : ' + CAST(Airline_Cities.[City Name] AS VARCHAR(50)) + ', ' + CAST(Airline_Cities.State AS VARCHAR(50)) + ', ' + CAST(Airline_Cities.Country AS VARCHAR(50)) + ' TO : ' + CAST(Airline_Cities_1.[City Name] AS VARCHAR(50)) + ', ' + CAST(Airline_Cities_1.State AS VARCHAR(50)) + ', ' + CAST(Airline_Cities_1.Country AS VARCHAR(50)) AS [Route Name] FROM Airline_Cities INNER JOIN Airline_Route ON Airline_Cities.CityID = Airline_Route.OriginalCityID INNER JOIN Airline_Cities AS Airline_Cities_1 ON Airline_Route.DestinationCityID = Airline_Cities_1.CityID">
        </asp:sqldatasource>
        <br />
        Days of Week
        <asp:customvalidator id="CustomValidator1" runat="server" errormessage="CustomValidator"
            onservervalidate="CustomValidator1_ServerValidate">*</asp:customvalidator>
        <asp:checkboxlist id="CheckBoxList1" runat="server" repeatcolumns="4">
            <asp:listitem>Mon</asp:listitem>
            <asp:listitem>Tue</asp:listitem>
            <asp:listitem>Wed</asp:listitem>
            <asp:listitem>Thu</asp:listitem>
            <asp:listitem>Fri</asp:listitem>
            <asp:listitem>Sat</asp:listitem>
            <asp:listitem>Sun</asp:listitem>
        </asp:checkboxlist>
        <br />
        Depart Time :
        <asp:textbox id="TextBox1" runat="server">
        </asp:textbox>
        <asp:customvalidator id="CustomValidator2" runat="server" errormessage="CustomValidator"
            onservervalidate="CustomValidator1_ServerValidate">Invalid Time</asp:customvalidator>
        <br />
        <asp:button id="Button1" runat="server" onclick="Button1_Click" text="Add Schedule" />
        <asp:Button ID="Button2" runat="server" PostBackUrl="~/Admin/ScheduleList.aspx" Text="Cancel" /><br />
        <asp:Label ID="lblWarm" runat="server"></asp:Label>
    </div>
</asp:content>
